-
Re: Formula problem
Hello @eatonbp Consider trying something like this: =COUNTIF([Project Risk]1:[Project Risk]48, "Green") If the formula is in row 49, I put 48 to eliminate the overlap. Let me know if that w…1 · -
Re: Multiple IF statements
Thanks for that, so the formula I provided anything inside these brackets [ ] need to be the column names you're referencing. Based on the screen shot it would go like this: =IF(AND([Tech/Set Up Pric…1 · -
Re: Formula Assistance 🙏
Explanation: [Education Expense]@row <= 5000: Checks if education expenses are within the allowed limit. MAX(0, [Education Expense]@row - 4500): Calculates how much of the education budget is affe…2 · -
Re: Where can I see all the API tokens being run in Smartsheet?
It's likely the person who is no longer working had their Smartsheet license deactivated, thus making their API token no longer valid. Is there code currently running with the previous API? If you ha…1 · -
Re: Where can I see all the API tokens being run in Smartsheet?
On the bottom left corner of the screen click on your profile. Then select "Personal Settings" Select API Access. You can generate a new token if the other is no longer working.1 ·